<?xml version="1.0" encoding="utf-8"?>
<!-- SlkSchema.xml - SharePoint Learning Kit (SLK) extensions to the Microsoft Learning Components (MLC) base schema -->
<StoreSchema xmlns="urn:schemas-microsoft-com:learning-components:learning-store-schema">
<!-- Common functions that return the learner assignment state information-->
<SqlBefore>
GO
CREATE FUNCTION GetLearnerAssignmentState(
@RootActivityId bigint,
@IsFinal bit,
@NonELearningStatus int,
@AttemptStatus int)
RETURNS int
AS
BEGIN
RETURN CASE WHEN @RootActivityId IS NOT NULL
THEN
-- e-learning content
CASE WHEN @AttemptStatus IS NULL
THEN 0 -- LearnerAssignmentState.NotStarted
ELSE
CASE WHEN @IsFinal = 1
THEN 3 -- LearnerAssignmentState.Final
ELSE
CASE WHEN @AttemptStatus = 0 OR @AttemptStatus = 3
THEN 1 -- LearnerAssignmentState.Active
ELSE 2 -- LearnerAssignmentState.Completed
END
END
END
ELSE
-- non-e-learning content
CASE WHEN @NonELearningStatus IS NULL
THEN 0 -- LearnerAssignmentState.NotStarted
ELSE
CASE WHEN @IsFinal = 1
THEN 3 -- LearnerAssignmentState.Final
ELSE
CASE WHEN @NonELearningStatus = 0 OR @NonELearningStatus = 3
THEN 1 -- LearnerAssignmentState.Active
ELSE 2 -- LearnerAssignmentState.Completed
END
END
END
END
END
GO
CREATE FUNCTION IsLearnerAssignmentStarted(
@RootActivityId bigint,
@NonELearningStatus int,
@AttemptStatus int)
RETURNS int
AS
BEGIN
RETURN CASE WHEN @RootActivityId IS NOT NULL
THEN
-- e-learning content
CASE WHEN @AttemptStatus IS NULL
THEN 0 -- LearnerAssignmentState.NotStarted
ELSE 1 -- LearnerAssignmentState.Active or Completed or Final
END
ELSE
-- non-e-learning content
CASE WHEN @NonELearningStatus IS NULL
THEN 0 -- LearnerAssignmentState.NotStarted
ELSE 1 -- LearnerAssignmentState.Active or Completed or Final
END
END
END
GO
</SqlBefore>
<Enum Name="LearnerAssignmentState">
<Values>
<Value Name="NotStarted" Value="0">
<Documentation xmlns="">
The learner has not yet begun the assignment.
</Documentation>
</Value>
<Value Name="Active" Value="1">
<Documentation xmlns="">
The learner has begun working on the assignment, but has not yet submitted it
to the instructor. For self-assigned assignments, the learner has not yet marked
the assignment as "complete".
</Documentation>
</Value>
<Value Name="Completed" Value="2">
<Documentation xmlns="">
The learner submitted the assignment to the instructor, but the instructor has
not yet completed grading of the
<a href="SlkConcepts.htm#Assignments">learner assignment</a>.
Self-assigned and auto-returned
assignments do not stay in this state -- they're automatically transitioned to
Final state.
</Documentation>
</Value>
<Value Name="Final" Value="3">
<Documentation xmlns="">
The instructor has graded the
<a href="SlkConcepts.htm#Assignments">learner assignment</a>
(or the learner assignment was
automatically graded, or both) and returned it to the learner (or it was
automatically returned to the learner).
</Documentation>
</Value>
</Values>
<Documentation>
<Summary xmlns="">
Represents the <a href="SlkApi.htm#LearnerAssignmentStates">state</a>
of a <a href="SlkConcepts.htm#Assignments">learner assignment</a>.
</Summary>
<Remarks xmlns="">
<para>
For more information, see <a href="SlkApi.htm#LearnerAssignmentStates">Learner
Assignment States.</a></para>
<para>
This enumeration is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Remarks>
</Documentation>
</Enum>
<ItemType Name="SiteSettingsItem">
<Documentation>
<Summary xmlns="">
<para>
Each item of this <a href="SlkSchema.htm">LearningStore item type</a> contains the
SLK Settings corresponding to a given SharePoint site collectino (SPSite).
</para>
<para>
This item type is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="SiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SiteGuid is the GUID of the SharePoint site collection (SPSite) that this
<a href="Microsoft.SharePointLearningKit.Schema.SiteSettingsItem.Class.htm">SiteSettingsItem</a>
refers to.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="SettingsXml" Type="String">
<Documentation>
<Summary xmlns="">
<para>
SettingsXml is the <a href="SlkSettings.htm">SLK Settings</a> XML of the
SharePoint site collection (SPSite) that this
<a href="Microsoft.SharePointLearningKit.Schema.SiteSettingsItem.Class.htm">SiteSettingsItem</a>
refers to.
</para>
</Summary>
<Remarks xmlns="">
<para>
This XML is stored as a string, not as a SQL Server XML column, to allow for
line numbers within error messages.
</para>
</Remarks>
</Documentation>
</Property>
<!-- SLK Settings; note type isn't "Xml" (doesn't support IXmlLineInfo) -->
<Property Name="SettingsXmlLastModified" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>
SettingsXmlLastModified is the date/time (UTC) that the SLK Settings referred
to by this
<a href="Microsoft.SharePointLearningKit.Schema.SiteSettingsItem.Class.htm">SiteSettingsItem</a>
was uploaded.
</para>
</Summary>
</Documentation>
</Property>
<!-- when SettingsXml last uploaded-->
</Properties>
</ItemType>
<ItemType Name="AssignmentItem">
<Documentation>
<Summary xmlns="">
<para>
Each item of this <a href="SlkSchema.htm">LearningStore item type</a> contains
information about one <a href="SlkConcepts.htm#Assignments">assignment</a>,
i.e. one <a href="SlkConcepts.htm#Packages">organization</a> of one e-learning
package, or one <a href="SlkConcepts.htm#Packages">non-e-learning document</a>,
assigned to one or more learners, with zero or more instructors.
</para>
<para>
This item type is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
For each learner on this assignment, there is one
<a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.Class.htm">LearnerAssignmentItem</a>.
For each instructor on this assignment, there is one
<a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.Class.htm">InstructorAssignmentItem</a>.
If this assignment is associated with an
<a href="SlkConcepts.htm#Packages">e-learning package</a> (not a non-e-learning
document), then when the learner begins the assignment an MLC
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.Class.htm">AttemptItem</a> is created.
</para>
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="SPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPSiteGuid is the GUID of the SharePoint site collection (SPSite) that this
assignment is associated with.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.SPSiteGuid.Property.htm">AssignmentProperties.SPSiteGuid</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="SPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPWebGuid is the GUID of the SharePoint Web site (SPWeb) that this assignment is
associated with.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.SPWebGuid.Property.htm">AssignmentProperties.SPWebGuid</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- "RootActivityId" is NULL for non-e-learning content, "NonELearningLocation" is NULL otherwise -->
<Property Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
If e-learning content was assigned, RootActivityId is the
<a href="Microsoft.LearningComponents.Storage.ActivityPackageItemIdentifier.Class.htm">ActivityPackageItemIdentifier</a>
of the assigned SCORM <a href="SlkConcepts.htm#Packages">organization</a>.
If non-e-learning content was assigned, RootActivityId is <b>null</b> -- in that
case, <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">NonELearningLocation</a> is used.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="NonELearningLocation" Type="String" Length="1000" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
If non-e-learning content was assigned, NonELearningLocation is the
MLC SharePoint location string (i.e. the same value used in
<a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>)
of the assigned <a href="SlkConcepts.htm#Packages">non-e-learning</a> document.
If e-learning content was assigned, NonELearningLocation is <b>null</b> -- in that
case, <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">RootActivityId</a> is used.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="Title" Type="String" Length="1000">
<Documentation>
<Summary xmlns="">
<para>
Title is the title of the assignment.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.Title.Property.htm">AssignmentProperties.Title</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="StartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>
StartDate is the start date/time (UTC) of the assignment.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.StartDate.Property.htm">AssignmentProperties.StartDate</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- UTC; no start time -> DateTime.Now (better for reporting than NULL) -->
<Property Name="DueDate" Type="DateTime" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
DueDate is the due date/time (UTC) of the assignment, or <b>null</b> if the
assignment has no due date/time.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.DueDate.Property.htm">AssignmentProperties.DueDate</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- UTC -->
<Property Name="PointsPossible" Type="Single" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
The nominal maximum number of points that can be awarded to a learner on this
assignment, or <b>null</b> if this information is not provided. The actual
number of points awarded may exceed this value.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.PointsPossible.Property.htm">AssignmentProperties.PointsPossible</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- non-scaled -->
<Property Name="Description" Type="String">
<Documentation>
<Summary xmlns="">
<para>
Description is the description of the assignment, including instructions to the
learner (if any).
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.Description.Property.htm">AssignmentProperties.Description</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- unlimited length -->
<Property Name="AutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
AutoReturn is <b>true</b> if the assignment should be automatically returned to
learners when they submit it to the instructor or (for self-assigned assignments)
mark the assignment as complete. If <b>false</b>, the instructor has an
opportunity to grade the learner's work. AutoReturn should always be <b>true</b>
for self-assigned assignments.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.AutoReturn.Property.htm">AssignmentProperties.AutoReturn</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="ShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
ShowAnswersToLearners is <b>true</b> if answers will be shown to the learner when a
<a href="SlkConcepts.htm#Assignments">learner assignment</a>
associated with this assignment is returned to the learner.
This only applies to certain types of e-learning content.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.ShowAnswersToLearners.Property.htm">AssignmentProperties.ShowAnswersToLearners</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="CreatedBy" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
CreatedBy is the
<a href="Microsoft.LearningComponents.Storage.UserItemIdentifier.Class.htm">UserItemIdentifier</a>
of the user who created the assignment.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.CreatedById.Property.htm">AssignmentProperties.CreatedById</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="DateCreated" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>
DateCreated is the date/time (UTC) that the assignment was created.
Corresponds to <a href="Microsoft.SharePointLearningKit.AssignmentProperties.DateCreated.Property.htm">AssignmentProperties.DateCreated</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- UTC -->
</Properties>
<Indexes>
<Index>
CREATE INDEX SPWebIndex
ON AssignmentItem(SPWebGuid)
</Index>
</Indexes>
<GrantDeleteRight>
<!-- Is the user an instructor on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM InstructorAssignmentItem iai
INNER JOIN UserItem ui ON iai.InstructorId=ui.Id
WHERE iai.AssignmentId=@Id AND
ui.[Key]=@UserKey
) THEN 1 ELSE 0 END
</Expression>
<!-- Did the user create the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM AssignmentItem ai
INNER JOIN UserItem ui ON ai.CreatedBy=ui.Id
WHERE ai.Id=@Id AND
ui.[Key]=@UserKey
) THEN 1 ELSE 0 END
</Expression>
</GrantDeleteRight>
</ItemType>
<ItemType Name="InstructorAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>
Each item of this <a href="SlkSchema.htm">LearningStore item type</a> contains
information about one
<a href="SlkConcepts.htm#Assignments">instructor assignment</a>,
i.e. the mapping of one instructor to one
<a href="SlkConcepts.htm#Assignments">assignment</a>.
For example, if an assignment has three instructors, there will be three
InstructorAssignmentItem table rows associated with that assignment.
</para>
<para>
This item type is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>
AssignmentId is the
<a href="Microsoft.SharePointLearningKit.AssignmentItemIdentifier.Class.htm">AssignmentItemIdentifier</a>
of the assignment associated with this
<a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.Class.htm">InstructorAssignmentItem</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="InstructorId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>
InstructorId is the
<a href="Microsoft.LearningComponents.Storage.UserItemIdentifier.Class.htm">UserItemIdentifier</a>
of the instructor associated with this
<a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.Class.htm">InstructorAssignmentItem</a>.
</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX AssignmentIndex
ON InstructorAssignmentItem(AssignmentId,InstructorId)
</Index>
<Index>
CREATE INDEX InstructorIndex
ON InstructorAssignmentItem(InstructorId,AssignmentId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="LearnerAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>
Each item of this <a href="SlkSchema.htm">LearningStore item type</a> contains
information about one <a href="SlkConcepts.htm#Assignments">learner assignment</a>,
i.e. the mapping of one learner to one
<a href="SlkConcepts.htm#Assignments">assignment</a>. For example, if an
assignment has 30 learners, there will be 30 LearnerAssignmentItem table rows
associated with that assignment.
</para>
<para>
This item type is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>
AssignmentId is the
<a href="Microsoft.SharePointLearningKit.AssignmentItemIdentifier.Class.htm">AssignmentItemIdentifier</a>
of the assignment associated with this
<a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.Class.htm">LearnerAssignmentItem</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>
LearnerId is the
<a href="Microsoft.LearningComponents.Storage.UserItemIdentifier.Class.htm">UserItemIdentifier</a>
of the learner associated with this
<a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.Class.htm">InstructorAssignmentItem</a>.
Corresponds to <a href="Microsoft.SharePointLearningKit.GradingProperties.LearnerId.Property.htm">GradingProperties.LearnerId</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- CascadeDelete="true" -->
<Property Name="IsFinal" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
IsFinal is <b>true</b> if the
<a href="SlkApi.htm#LearnerAssignmentStates">learner assignment state</a> is
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">Final</a>.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="NonELearningStatus" Type="Enum" EnumName="AttemptStatus" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
NonELearningStatus is the
<a href="Microsoft.LearningComponents.AttemptStatus.Enumeration.htm">AttemptStatus</a>
of the
<a href="SlkConcepts.htm#Assignments">learner assignment</a>, if a
<a href="SlkConcepts.htm#Packages">non-e-learning document</a> was assigned
(unused if an e-learning package was assigned). <b>null</b> if the learner hasn't
yet started the assignment.
</para>
</Summary>
</Documentation>
</Property>
<!-- NULL means "not started" -->
<Property Name="FinalPoints" Type="Single" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>
FinalPoints is the number of points the learner received on this
<a href="SlkConcepts.htm#Assignments">learner assignment</a>.
When the learner submits the assignment, FinalPoints is initially the same as
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>,
but the instructor may manually change the value of FinalPoints. For example, the
instructor may award bonus points to the learner. <b>null</b> if the final points
value is blank.
Corresponds to <a href="Microsoft.SharePointLearningKit.GradingProperties.FinalPoints.Property.htm">GradingProperties.FinalPoints</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- non-scaled -->
<Property Name="InstructorComments" Type="String">
<Documentation>
<Summary xmlns="">
<para>
InstructorComments contains free-form comments, if any, from the instructor
about this
<a href="SlkConcepts.htm#Assignments">learner assignment</a>.
Corresponds to <a href="Microsoft.SharePointLearningKit.GradingProperties.InstructorComments.Property.htm">GradingProperties.InstructorComments</a>.
</para>
</Summary>
</Documentation>
</Property>
<!-- unlimited length -->
</Properties>
<Indexes>
<Index>
CREATE INDEX AssignmentIndex
ON LearnerAssignmentItem(AssignmentId,LearnerId)
INCLUDE (IsFinal, NonELearningStatus)
</Index>
<Index>
CREATE INDEX LearnerIndex
ON LearnerAssignmentItem(LearnerId,AssignmentId)
</Index>
</Indexes>
</ItemType>
<ExtendItemType Name="PackageItem">
<Properties>
<Property Name="Warnings" Type="Xml" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>
Warnings contains warnings that SLK detected when the package was
<a href="Microsoft.SharePointLearningKit.SlkStore.RegisterPackage.Method.htm">registered</a>.
This XML consists of a root "<Warnings>" element containing one
"<Warning>" element per warning, each of which contains the text of the
warning as the content of the element plus the following attributes: the
"Code" attribute contains the warning's validation result code, and "Type"
attribute contains the warning's type, either "Error" or "Warning". Warnings
is <b>null</b> if there are no warnings.
</para>
<para>
This property/column is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
</Documentation>
</Property>
</Properties>
</ExtendItemType>
<ExtendItemType Name="AttemptItem">
<Properties>
<Property Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" Nullable="true" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>
LearnerAssignmentId is the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentItemIdentifier.Class.htm">LearnerAssignmentItemIdentifier</a>
of the
<a href="SlkConcepts.htm#Assignments">learner assignment</a>
associated with this attempt.
</para>
<para>
This property/column is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
</Documentation>
<Default Null="true" />
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX LearnerAssignmentIndex
ON AttemptItem(LearnerAssignmentId)
INCLUDE (AttemptStatus)
</Index>
</Indexes>
</ExtendItemType>
<ItemType Name="UserWebListItem">
<Documentation>
<Summary xmlns="">
<para>
Each item of this <a href="SlkSchema.htm">LearningStore item type</a> represents
one entry in one user's <b>user Web list</b>, for one site collection. A user Web
list is the list of Web sites that appears on the SLK E-Learning Actions page for
all document libraries within a given site collection. Each user has at most one
user Web list for each site collection (SPSite).
</para>
<para>
This item type is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="OwnerKey" Type="String" Length="250">
<Documentation>
<Summary xmlns="">
<para>
OwnerKey is the
<a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>
value of the user that owns this user Web list item.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="SPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPSiteGuid is the GUID of the SharePoint site collection (SPSite) that this
user Web list item is associated with.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="SPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPWebGuid is the GUID of the SharePoint Web site (SPWeb) that this user Web list
item is associated with.
</para>
</Summary>
</Documentation>
</Property>
<Property Name="LastAccessTime" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>
LastAccessTime is the date/time (UTC) that this user Web list item was last
accessed via an operation such as assignment creation. (Viewing the item within
the list on the E-Learning Actions page in SLK doesn't count as an access.)
</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX OwnerIndex
ON UserWebListItem(OwnerKey)
</Index>
</Indexes>
</ItemType>
<View Name="LearnerAssignmentView">
<Documentation>
<Summary xmlns="">
<para>
This <a href="SlkSchema.htm">LearningStore view</a> contains specific information
about all <a href="SlkConcepts.htm#Assignments">learner assignments</a>.
By default, access is granted to no users; consider using
<a href="SlkSchema.htm">other views</a>.
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to no users.
</para>
</Remarks>
</Documentation>
<Columns>
<!-- from LearnerAssignmentItem: -->
<Column Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>
LearnerAssignmentId corresponds to <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.Id.Field.htm">LearnerAssignmentItem.Id</a>.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>
LearnerId corresponds to <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.LearnerId.Field.htm">LearnerAssignmentItem.LearnerId</a>.
</para>
</Summary>
</Documentation>
</Column>
<!-- from AssignmentItem: -->
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
AssignmentAutoReturn corresponds to <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>
RootActivityId corresponds to <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">AssignmentItem.RootActivityId</a>.
</para>
</Summary>
</Documentation>
</Column>
<!-- from AttemptItem: -->
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem">
<Documentation>
<Summary xmlns="">
<para>
AttemptId corresponds to <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.Id.Field.htm">AttemptItem.Id</a>.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptGradedPoints" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AttemptGradedPoints holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- computed: -->
<Column Name="LearnerAssignmentState" Type="Enum" EnumName="LearnerAssignmentState">
<Documentation>
<Summary xmlns="">
<para>
LearnerAssignmentState is the state of this <a href="SlkConcepts.htm#Assignments">learner assignment</a>.
</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from LearnerAssignmentItem -----
lai.Id LearnerAssignmentId,
lai.LearnerId LearnerId,
----- from AssignmentItem -----
asi.AutoReturn AssignmentAutoReturn,
asi.RootActivityId RootActivityId,
----- from AttemptItem -----
ati.Id AttemptId,
ati.TotalPoints AttemptGradedPoints,
----- computed LearnerAssignmentState -----
dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) LearnerAssignmentState
-----
FROM LearnerAssignmentItem lai
INNER JOIN AssignmentItem asi ON lai.AssignmentId = asi.Id
LEFT OUTER JOIN AttemptItem ati ON ati.LearnerAssignmentId = lai.Id
</Implementation>
</View>
<View Name="AssignmentPropertiesView">
<Documentation>
<Summary xmlns="">
<para>
This <a href="SlkSchema.htm">LearningStore view</a> contains information about one
<a href="SlkConcepts.htm#Assignments">SLK assignment</a>, as specified by the
"AssignmentId" view parameter (the
<a href="Microsoft.SharePointLearningKit.AssignmentItemIdentifier.Class.htm">AssignmentItemIdentifier</a> of an assignment) and the "IsInstructor" view parameter (<b>true</b> if the
current user is an instructor on the assignment, <b>false</b> if they're a
learner).
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to instructors and learners of the assignment.
Learners have no access before the start date of the assignment.
</para>
</Remarks>
</Documentation>
<Parameters>
<Parameter Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem" />
<Parameter Name="IsInstructor" Type="Boolean" />
</Parameters>
<Columns>
<!-- from AssignmentItem: -->
<Column Name="AssignmentSPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPSiteGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPSiteGuid.Field.htm">AssignmentItem.SPSiteGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPWebGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPWebGuid.Field.htm">AssignmentItem.SPWebGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentNonELearningLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentNonELearningLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">AssignmentItem.NonELearningLocation</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentTitle" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentTitle holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Title.Field.htm">AssignmentItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentStartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentStartDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.StartDate.Field.htm">AssignmentItem.StartDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDueDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDueDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DueDate.Field.htm">AssignmentItem.DueDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentPointsPossible" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AssignmentPointsPossible holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.PointsPossible.Field.htm">AssignmentItem.PointsPossible</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDescription" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentDescription holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Description.Field.htm">AssignmentItem.Description</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentAutoReturn holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentShowAnswersToLearners holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.ShowAnswersToLearners.Field.htm">AssignmentItem.ShowAnswersToLearners</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedById" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedById holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.CreatedBy.Field.htm">AssignmentItem.CreatedBy</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByName" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDateCreated" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDateCreated holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DateCreated.Field.htm">AssignmentItem.DateCreated</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>RootActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">AssignmentItem.RootActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from AssignmentItem -----
asi.Id AssignmentId,
asi.SPSiteGuid AssignmentSPSiteGuid,
asi.SPWebGuid AssignmentSPWebGuid,
asi.NonELearningLocation AssignmentNonELearningLocation,
asi.Title AssignmentTitle,
asi.StartDate AssignmentStartDate,
asi.DueDate AssignmentDueDate,
asi.PointsPossible AssignmentPointsPossible,
asi.Description AssignmentDescription,
asi.AutoReturn AssignmentAutoReturn,
asi.ShowAnswersToLearners AssignmentShowAnswersToLearners,
asi.CreatedBy AssignmentCreatedById,
cbui.[Name] AssignmentCreatedByName,
cbui.[Key] AssignmentCreatedByKey,
asi.DateCreated AssignmentDateCreated,
asi.RootActivityId RootActivityId,
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation
-----
FROM AssignmentItem asi
INNER JOIN UserItem cbui ON cbui.Id = asi.CreatedBy
LEFT OUTER JOIN ActivityPackageItem api ON asi.RootActivityId = api.Id
LEFT OUTER JOIN PackageItem pki ON api.PackageId = pki.Id
WHERE asi.Id = @AssignmentId
</Implementation>
<GrantQueryRight>
<!-- Is the user an instructor or learner on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM AssignmentItem asi
LEFT OUTER JOIN LearnerAssignmentItem lai ON lai.AssignmentId = asi.Id
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = asi.Id
LEFT OUTER JOIN UserItem lui ON lai.LearnerId = lui.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE asi.Id = @AssignmentId AND
(((lui.[Key] = @UserKey) AND (@IsInstructor = 0) AND (GETUTCDATE() >= asi.StartDate))
OR
((iui.[Key]=@UserKey) AND (@IsInstructor = 1)))
) THEN 1 ELSE 0 END
</Expression>
</GrantQueryRight>
</View>
<View Name="AssignmentListForInstructors">
<Documentation>
<Summary xmlns="">
<para>
Each row of this <a href="SlkSchema.htm">LearningStore view</a> contains
information about one
<a href="SlkConcepts.htm#Assignments">assignment</a>, as well as
information about the e-learning package (if any) associated with the assignment.
This view contains one row for each assignment for which the current user is an
instructor.
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to all users.
</para>
</Remarks>
</Documentation>
<Columns>
<!-- from AssignmentItem: -->
<Column Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Id.Field.htm">AssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPSiteGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPSiteGuid.Field.htm">AssignmentItem.SPSiteGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPWebGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPWebGuid.Field.htm">AssignmentItem.SPWebGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentNonELearningLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentNonELearningLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">AssignmentItem.NonELearningLocation</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentTitle" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentTitle holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Title.Field.htm">AssignmentItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentStartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentStartDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.StartDate.Field.htm">AssignmentItem.StartDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDueDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDueDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DueDate.Field.htm">AssignmentItem.DueDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentPointsPossible" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AssignmentPointsPossible holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.PointsPossible.Field.htm">AssignmentItem.PointsPossible</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDescription" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentDescription holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Description.Field.htm">AssignmentItem.Description</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentAutoReturn holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentShowAnswersToLearners holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.ShowAnswersToLearners.Field.htm">AssignmentItem.ShowAnswersToLearners</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedById" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedById holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.CreatedBy.Field.htm">AssignmentItem.CreatedBy</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByName" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDateCreated" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDateCreated holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DateCreated.Field.htm">AssignmentItem.DateCreated</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>RootActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">AssignmentItem.RootActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- computed: -->
<Column Name="CountTotal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountTotal is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountNotStarted" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountNotStarted is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.NotStarted</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountActive" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountActive is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Active</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountCompleted" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountCompleted is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Completed</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountFinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountFinal is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Final</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountStarted" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountStarted is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are not in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.NotStarted</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountNotStartedOrActive" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountNotStartedOrActive is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.NotStarted</a> or
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Active</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountCompletedOrFinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountCompletedOrFinal is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Completed</a> or
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Final</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CountNotFinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>CountNotFinal is the number of <a href="SlkConcepts.htm#Assignments">learner assignments</a> that are not in the
<a href="Microsoft.SharePointLearningKit.LearnerAssignmentState.Enumeration.htm">LearnerAssignmentState.Final</a> state.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MinGradedPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>MinGradedPoints is the minimum value of
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MaxGradedPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>MaxGradedPoints is the maximum value of
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AvgGradedPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>AvgGradedPoints is the average value of
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MinFinalPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>MinFinalPoints is the minimum value of
<a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.FinalPoints.Field.htm">LearnerAssignmentItem.FinalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MaxFinalPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>MaxFinalPoints is the maximum value of
<a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.FinalPoints.Field.htm">LearnerAssignmentItem.FinalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AvgFinalPoints" Type="Double">
<Documentation>
<Summary xmlns="">
<para>AvgFinalPoints is the average value of
<a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.FinalPoints.Field.htm">LearnerAssignmentItem.FinalPoints</a>
among the <a href="SlkConcepts.htm#Assignments">learner assignments</a>.</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from AssignmentItem -----
asi.Id AssignmentId,
asi.SPSiteGuid AssignmentSPSiteGuid,
asi.SPWebGuid AssignmentSPWebGuid,
asi.NonELearningLocation AssignmentNonELearningLocation,
asi.Title AssignmentTitle,
asi.StartDate AssignmentStartDate,
asi.DueDate AssignmentDueDate,
asi.PointsPossible AssignmentPointsPossible,
asi.Description AssignmentDescription,
asi.AutoReturn AssignmentAutoReturn,
asi.ShowAnswersToLearners AssignmentShowAnswersToLearners,
asi.CreatedBy AssignmentCreatedById,
cbui.[Name] AssignmentCreatedByName,
cbui.[Key] AssignmentCreatedByKey,
asi.DateCreated AssignmentDateCreated,
asi.RootActivityId RootActivityId,
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation,
----- from learner assignment computed info -----
ISNULL(la.CountTotal,0) CountTotal,
ISNULL(la.CountNotStarted,0) CountNotStarted,
ISNULL(la.CountActive,0) CountActive,
ISNULL(la.CountCompleted,0) CountCompleted,
ISNULL(la.CountFinal,0) CountFinal,
ISNULL(la.CountStarted,0) CountStarted,
ISNULL(la.CountNotStartedOrActive,0) CountNotStartedOrActive,
ISNULL(la.CountCompletedOrFinal,0) CountCompletedOrFinal,
ISNULL(la.CountNotFinal,0) CountNotFinal,
la.MinGradedPoints MinGradedPoints,
la.MaxGradedPoints MaxGradedPoints,
la.AvgGradedPoints AvgGradedPoints,
la.MinFinalPoints MinFinalPoints,
la.MaxFinalPoints MaxFinalPoints,
la.AvgFinalPoints AvgFinalPoints
-----
FROM AssignmentItem asi
INNER JOIN UserItem cbui ON cbui.Id = asi.CreatedBy
INNER JOIN InstructorAssignmentItem iai ON asi.Id = iai.AssignmentId
INNER JOIN UserItem iui ON iai.InstructorId = iui.Id
LEFT OUTER JOIN ActivityPackageItem api ON asi.RootActivityId = api.Id
LEFT OUTER JOIN PackageItem pki ON api.PackageId = pki.Id
LEFT OUTER JOIN (
SELECT
----- from Assignment -----
lai.AssignmentId,
----- computed CountTotal -----
COUNT(lai.Id) CountTotal,
----- computed CountNotStarted -----
COUNT(CASE WHEN dbo.IsLearnerAssignmentStarted(asi.RootActivityId, lai.NonELearningStatus, ati.AttemptStatus) = 0 THEN 1 ELSE NULL END) CountNotStarted,
----- computed CountActive -----
COUNT(CASE WHEN dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) = 1 THEN 1 ELSE NULL END) CountActive,
----- computed CountCompleted -----
COUNT(CASE WHEN dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) = 2 THEN 1 ELSE NULL END) CountCompleted,
----- computed CountFinal -----
COUNT(CASE WHEN lai.IsFinal = 1 THEN 1 ELSE NULL END) CountFinal,
----- computed CountStarted -----
COUNT(CASE WHEN dbo.IsLearnerAssignmentStarted(asi.RootActivityId, lai.NonELearningStatus, ati.AttemptStatus) <> 0 THEN 1 ELSE NULL END) CountStarted,
----- computed CountNotStartedOrActive -----
COUNT(CASE WHEN dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) IN (0,1) THEN 1 ELSE NULL END) CountNotStartedOrActive,
----- computed CountCompletedOrFinal -----
COUNT(CASE WHEN dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) IN (2,3) THEN 1 ELSE NULL END) CountCompletedOrFinal,
----- computed CountNotFinal -----
COUNT(CASE WHEN lai.IsFinal = 0 THEN 1 ELSE NULL END) CountNotFinal,
----- computed MinGradedPoints -----
MIN(ati.TotalPoints) MinGradedPoints,
----- computed MaxGradedPoints -----
MAX(ati.TotalPoints) MaxGradedPoints,
----- computed AvgGradedPoints -----
AVG(ati.TotalPoints) AvgGradedPoints,
----- computed MinFinalPoints -----
MIN(lai.FinalPoints) MinFinalPoints,
----- computed MaxFinalPoints -----
MAX(lai.FinalPoints) MaxFinalPoints,
----- computed AvgFinalPoints -----
AVG(lai.FinalPoints) AvgFinalPoints
-----
FROM LearnerAssignmentItem lai
INNER JOIN AssignmentItem asi ON lai.AssignmentId = asi.Id
LEFT OUTER JOIN AttemptItem ati ON ati.LearnerAssignmentId = lai.Id
INNER JOIN InstructorAssignmentItem iai ON asi.Id = iai.AssignmentId
INNER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE iui.[Key] = @UserKey
GROUP BY lai.AssignmentId) AS la ON asi.Id = la.AssignmentId
WHERE iui.[Key] = @UserKey
</Implementation>
<GrantQueryRight>
<Expression>1</Expression>
</GrantQueryRight>
</View>
<View Name="InstructorAssignmentListForInstructors">
<Documentation>
<Summary xmlns="">
<para>
Each row of this <a href="SlkSchema.htm">LearningStore view</a> contains
information about one <a href="SlkConcepts.htm#Assignments">instructor
assignment</a>, as well as information about the e-learning package (if any)
associated with the assignment. This view returns one row for each instructor on
each assignment for which the current user is an instructor.
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to all users.
</para>
</Remarks>
</Documentation>
<Columns>
<!-- from InstructorAssignmentItem: -->
<Column Name="InstructorAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="InstructorAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>InstructorAssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.Id.Field.htm">InstructorAssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="InstructorId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>InstructorId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.InstructorAssignmentItem.InstructorId.Field.htm">InstructorAssignmentItem.InstructorId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="InstructorName" Type="String">
<Documentation>
<Summary xmlns="">
<para>InstructorName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the instructor.</para>
</Summary>
</Documentation>
</Column>
<Column Name="InstructorKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>InstructorKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the instructor.</para>
</Summary>
</Documentation>
</Column>
<!-- from AssignmentItem: -->
<Column Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Id.Field.htm">AssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPSiteGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPSiteGuid.Field.htm">AssignmentItem.SPSiteGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPWebGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPWebGuid.Field.htm">AssignmentItem.SPWebGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentNonELearningLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentNonELearningLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">AssignmentItem.NonELearningLocation</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentTitle" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentTitle holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Title.Field.htm">AssignmentItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentStartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentStartDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.StartDate.Field.htm">AssignmentItem.StartDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDueDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDueDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DueDate.Field.htm">AssignmentItem.DueDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentPointsPossible" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AssignmentPointsPossible holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.PointsPossible.Field.htm">AssignmentItem.PointsPossible</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDescription" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentDescription holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Description.Field.htm">AssignmentItem.Description</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentAutoReturn holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentShowAnswersToLearners holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.ShowAnswersToLearners.Field.htm">AssignmentItem.ShowAnswersToLearners</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedById" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedById holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.CreatedBy.Field.htm">AssignmentItem.CreatedBy</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByName" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageManifest" Type="Xml">
<Documentation>
<Summary xmlns="">
<para>PackageManifest holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Manifest.Field.htm">PackageItem.Manifest</a>.</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from InstructorAssignmentItem -----
iai.Id InstructorAssignmentId,
iai.InstructorId InstructorId,
iui.[Name] InstructorName,
iui.[Key] InstructorKey,
----- from AssignmentItem -----
asi.Id AssignmentId,
asi.SPSiteGuid AssignmentSPSiteGuid,
asi.SPWebGuid AssignmentSPWebGuid,
asi.NonELearningLocation AssignmentNonELearningLocation,
asi.Title AssignmentTitle,
asi.StartDate AssignmentStartDate,
asi.DueDate AssignmentDueDate,
asi.PointsPossible AssignmentPointsPossible,
asi.Description AssignmentDescription,
asi.AutoReturn AssignmentAutoReturn,
asi.ShowAnswersToLearners AssignmentShowAnswersToLearners,
asi.CreatedBy AssignmentCreatedById,
cbui.[Name] AssignmentCreatedByName,
cbui.[Key] AssignmentCreatedByKey,
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation,
pki.Manifest PackageManifest
-----
FROM InstructorAssignmentItem iai
INNER JOIN AssignmentItem asi ON iai.AssignmentId = asi.Id
INNER JOIN UserItem iui ON iui.Id = iai.InstructorId
INNER JOIN UserItem cbui ON cbui.Id = asi.CreatedBy
LEFT OUTER JOIN ActivityPackageItem api ON asi.RootActivityId = api.Id
LEFT OUTER JOIN PackageItem pki on api.PackageId = pki.Id
WHERE EXISTS
(
SELECT *
FROM InstructorAssignmentItem iai2
INNER JOIN UserItem ui2
ON iai2.InstructorId = ui2.Id
WHERE iai2.AssignmentId = asi.Id
AND ui2.[Key] = @UserKey
)
</Implementation>
<GrantQueryRight>
<Expression>1</Expression>
</GrantQueryRight>
</View>
<View Name="LearnerAssignmentListForLearners">
<Documentation>
<Summary xmlns="">
<para>
Each row of this <a href="SlkSchema.htm">LearningStore view</a> contains
information about one <a href="SlkConcepts.htm#Assignments">learner assignment</a>,
as well as information about the e-learning package (if any) associated with the
assignment. This view returns one row for each assignment for which the current
user is a learner, excluding assignments which have not yet started.
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to all users.
</para>
</Remarks>
</Documentation>
<Columns>
<!-- from LearnerAssignmentItem: -->
<Column Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>LearnerAssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.Id.Field.htm">LearnerAssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>LearnerId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.LearnerId.Field.htm">LearnerAssignmentItem.LearnerId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerName" Type="String">
<Documentation>
<Summary xmlns="">
<para>LearnerName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the learner.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>LearnerKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the learner.</para>
</Summary>
</Documentation>
</Column>
<Column Name="IsFinal" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>IsFinal holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.IsFinal.Field.htm">LearnerAssignmentItem.IsFinal</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="NonELearningStatus" Type="Enum" EnumName="AttemptStatus">
<Documentation>
<Summary xmlns="">
<para>NonELearningStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.NonELearningStatus.Field.htm">LearnerAssignmentItem.NonELearningStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="FinalPoints" Type="Single">
<Documentation>
<Summary xmlns="">
<para>FinalPoints holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.FinalPoints.Field.htm">LearnerAssignmentItem.FinalPoints</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="InstructorComments" Type="String">
<Documentation>
<Summary xmlns="">
<para>InstructorComments holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.InstructorComments.Field.htm">LearnerAssignmentItem.InstructorComments</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from AssignmentItem: -->
<Column Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Id.Field.htm">AssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPSiteGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPSiteGuid.Field.htm">AssignmentItem.SPSiteGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPWebGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPWebGuid.Field.htm">AssignmentItem.SPWebGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentNonELearningLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentNonELearningLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">AssignmentItem.NonELearningLocation</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentTitle" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentTitle holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Title.Field.htm">AssignmentItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentStartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentStartDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.StartDate.Field.htm">AssignmentItem.StartDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDueDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDueDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DueDate.Field.htm">AssignmentItem.DueDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentPointsPossible" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AssignmentPointsPossible holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.PointsPossible.Field.htm">AssignmentItem.PointsPossible</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDescription" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentDescription holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Description.Field.htm">AssignmentItem.Description</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentAutoReturn holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentShowAnswersToLearners holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.ShowAnswersToLearners.Field.htm">AssignmentItem.ShowAnswersToLearners</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedById" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedById holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.CreatedBy.Field.htm">AssignmentItem.CreatedBy</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByName" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDateCreated" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDateCreated holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DateCreated.Field.htm">AssignmentItem.DateCreated</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>RootActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">AssignmentItem.RootActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from AttemptItem: -->
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem">
<Documentation>
<Summary xmlns="">
<para>AttemptId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.Id.Field.htm">AttemptItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptCurrentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>AttemptCurrentActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.CurrentActivityId.Field.htm">AttemptItem.CurrentActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptSuspendedActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>AttemptSuspendedActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.SuspendedActivityId.Field.htm">AttemptItem.SuspendedActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptStatus" Type="Enum" EnumName="AttemptStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.AttemptStatus.Field.htm">AttemptItem.AttemptStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptFinishedTimestamp" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AttemptFinishedTimestamp holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.FinishedTimestamp.Field.htm">AttemptItem.FinishedTimestamp</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogDetailSequencing" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogDetailSequencing holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogDetailSequencing.Field.htm">AttemptItem.LogDetailSequencing</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogFinalSequencing" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogFinalSequencing holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogFinalSequencing.Field.htm">AttemptItem.LogFinalSequencing</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogRollup" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogRollup holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogRollup.Field.htm">AttemptItem.LogRollup</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptStartedTimestamp" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AttemptStartedTimestamp holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.StartedTimestamp.Field.htm">AttemptItem.StartedTimestamp</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptCompletionStatus" Type="Enum" EnumName="CompletionStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptCompletionStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.CompletionStatus.Field.htm">AttemptItem.CompletionStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptSuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptSuccessStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.SuccessStatus.Field.htm">AttemptItem.SuccessStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptGradedPoints" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AttemptGradedPoints holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- computed: -->
<Column Name="LearnerAssignmentState" Type="Enum" EnumName="LearnerAssignmentState">
<Documentation>
<Summary xmlns="">
<para>
LearnerAssignmentState is the state of this <a href="SlkConcepts.htm#Assignments">learner assignment</a>.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="HasInstructors" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
HasInstructors is <b>true</b> if the assignment has instructors, <b>false</b> if not. Note that self-assigned assignments have no instructors.
</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from LearnerAssignmentItem -----
lai.Id LearnerAssignmentId,
lai.LearnerId LearnerId,
lui.[Name] LearnerName,
lui.[Key] LearnerKey,
lai.IsFinal IsFinal,
lai.NonELearningStatus NonELearningStatus,
CASE WHEN lai.IsFinal = 1 THEN lai.FinalPoints ELSE NULL END
FinalPoints,
lai.InstructorComments InstructorComments,
----- from AssignmentItem -----
asi.Id AssignmentId,
asi.SPSiteGuid AssignmentSPSiteGuid,
asi.SPWebGuid AssignmentSPWebGuid,
asi.NonELearningLocation AssignmentNonELearningLocation,
asi.Title AssignmentTitle,
asi.StartDate AssignmentStartDate,
asi.DueDate AssignmentDueDate,
asi.PointsPossible AssignmentPointsPossible,
asi.Description AssignmentDescription,
asi.AutoReturn AssignmentAutoReturn,
asi.ShowAnswersToLearners AssignmentShowAnswersToLearners,
asi.CreatedBy AssignmentCreatedById,
cbui.[Name] AssignmentCreatedByName,
cbui.[Key] AssignmentCreatedByKey,
asi.DateCreated AssignmentDateCreated,
asi.RootActivityId RootActivityId,
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation,
----- from AttemptItem -----
ati.Id AttemptId,
ati.CurrentActivityId AttemptCurrentActivityId,
ati.SuspendedActivityId AttemptSuspendedActivityId,
ati.AttemptStatus AttemptStatus,
ati.FinishedTimestamp AttemptFinishedTimestamp,
ati.LogDetailSequencing AttemptLogDetailSequencing,
ati.LogFinalSequencing AttemptLogFinalSequencing,
ati.LogRollup AttemptLogRollup,
ati.StartedTimestamp AttemptStartedTimestamp,
ati.CompletionStatus AttemptCompletionStatus,
ati.SuccessStatus AttemptSuccessStatus,
ati.TotalPoints AttemptGradedPoints,
----- computed LearnerAssignmentState -----
dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) LearnerAssignmentState,
----- computed HasInstructors -----
CASE WHEN EXISTS
(
SELECT *
FROM InstructorAssignmentItem iaiH
WHERE iaiH.AssignmentId = asi.Id
) THEN 1 ELSE 0 END HasInstructors
-----
FROM LearnerAssignmentItem lai
INNER JOIN AssignmentItem asi ON lai.AssignmentId = asi.Id
INNER JOIN UserItem lui ON lui.Id = lai.LearnerId
INNER JOIN UserItem cbui ON cbui.Id = asi.CreatedBy
LEFT OUTER JOIN ActivityPackageItem api ON asi.RootActivityId = api.Id
LEFT OUTER JOIN PackageItem pki on api.PackageId = pki.Id
LEFT OUTER JOIN AttemptItem ati ON ati.LearnerAssignmentId = lai.Id
WHERE lui.[Key] = @UserKey
AND GETUTCDATE() >= asi.StartDate
</Implementation>
<GrantQueryRight>
<Expression>1</Expression>
</GrantQueryRight>
</View>
<View Name="LearnerAssignmentListForInstructors">
<Documentation>
<Summary xmlns="">
<para>
Each row of this <a href="SlkSchema.htm">LearningStore view</a> contains
information about one <a href="SlkConcepts.htm#Assignments">learner assignment</a>,
as well as information about the e-learning package (if any) associated with the
assignment. This view returns one row for each learner on each assignment for
which the current user is an instructor.
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to all users.
</para>
</Remarks>
</Documentation>
<Columns>
<!-- from LearnerAssignmentItem: -->
<Column Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem">
<Documentation>
<Summary xmlns="">
<para>LearnerAssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.Id.Field.htm">LearnerAssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>LearnerId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.LearnerId.Field.htm">LearnerAssignmentItem.LearnerId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerName" Type="String">
<Documentation>
<Summary xmlns="">
<para>LearnerName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the learner.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LearnerKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>LearnerKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the learner.</para>
</Summary>
</Documentation>
</Column>
<Column Name="IsFinal" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>IsFinal holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.IsFinal.Field.htm">LearnerAssignmentItem.IsFinal</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="NonELearningStatus" Type="Enum" EnumName="AttemptStatus">
<Documentation>
<Summary xmlns="">
<para>NonELearningStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.NonELearningStatus.Field.htm">LearnerAssignmentItem.NonELearningStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="FinalPoints" Type="Single">
<Documentation>
<Summary xmlns="">
<para>FinalPoints holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.FinalPoints.Field.htm">LearnerAssignmentItem.FinalPoints</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="InstructorComments" Type="String">
<Documentation>
<Summary xmlns="">
<para>InstructorComments holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.LearnerAssignmentItem.InstructorComments.Field.htm">LearnerAssignmentItem.InstructorComments</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from AssignmentItem: -->
<Column Name="AssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="AssignmentItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Id.Field.htm">AssignmentItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPSiteGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPSiteGuid.Field.htm">AssignmentItem.SPSiteGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentSPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>AssignmentSPWebGuid holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.SPWebGuid.Field.htm">AssignmentItem.SPWebGuid</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentNonELearningLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentNonELearningLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.NonELearningLocation.Field.htm">AssignmentItem.NonELearningLocation</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentTitle" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentTitle holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Title.Field.htm">AssignmentItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentStartDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentStartDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.StartDate.Field.htm">AssignmentItem.StartDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDueDate" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AssignmentDueDate holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.DueDate.Field.htm">AssignmentItem.DueDate</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentPointsPossible" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AssignmentPointsPossible holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.PointsPossible.Field.htm">AssignmentItem.PointsPossible</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentDescription" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentDescription holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.Description.Field.htm">AssignmentItem.Description</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentAutoReturn" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentAutoReturn holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.AutoReturn.Field.htm">AssignmentItem.AutoReturn</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentShowAnswersToLearners" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AssignmentShowAnswersToLearners holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.ShowAnswersToLearners.Field.htm">AssignmentItem.ShowAnswersToLearners</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedById" Type="ItemIdentifier" ReferencedItemTypeName="UserItem">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedById holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.CreatedBy.Field.htm">AssignmentItem.CreatedBy</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByName" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByName holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Name.Field.htm">UserItem.Name</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AssignmentCreatedByKey" Type="String">
<Documentation>
<Summary xmlns="">
<para>AssignmentCreatedByKey holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.UserItem.Key.Field.htm">UserItem.Key</a>. Refers to the user who created the assignment.</para>
</Summary>
</Documentation>
</Column>
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>RootActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AssignmentItem.RootActivityId.Field.htm">AssignmentItem.RootActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageManifest" Type="Xml">
<Documentation>
<Summary xmlns="">
<para>PackageManifest holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Manifest.Field.htm">PackageItem.Manifest</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from AttemptItem: -->
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem">
<Documentation>
<Summary xmlns="">
<para>AttemptId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.Id.Field.htm">AttemptItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptCurrentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>AttemptCurrentActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.CurrentActivityId.Field.htm">AttemptItem.CurrentActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptSuspendedActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>AttemptSuspendedActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.SuspendedActivityId.Field.htm">AttemptItem.SuspendedActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptStatus" Type="Enum" EnumName="AttemptStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.AttemptStatus.Field.htm">AttemptItem.AttemptStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptFinishedTimestamp" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AttemptFinishedTimestamp holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.FinishedTimestamp.Field.htm">AttemptItem.FinishedTimestamp</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogDetailSequencing" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogDetailSequencing holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogDetailSequencing.Field.htm">AttemptItem.LogDetailSequencing</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogFinalSequencing" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogFinalSequencing holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogFinalSequencing.Field.htm">AttemptItem.LogFinalSequencing</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptLogRollup" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>AttemptLogRollup holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LogRollup.Field.htm">AttemptItem.LogRollup</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptStartedTimestamp" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>AttemptStartedTimestamp holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.StartedTimestamp.Field.htm">AttemptItem.StartedTimestamp</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptCompletionStatus" Type="Enum" EnumName="CompletionStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptCompletionStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.CompletionStatus.Field.htm">AttemptItem.CompletionStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptSuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Documentation>
<Summary xmlns="">
<para>AttemptSuccessStatus holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.SuccessStatus.Field.htm">AttemptItem.SuccessStatus</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="AttemptGradedPoints" Type="Single">
<Documentation>
<Summary xmlns="">
<para>AttemptGradedPoints holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.TotalPoints.Field.htm">AttemptItem.TotalPoints</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- computed: -->
<Column Name="LearnerAssignmentState" Type="Enum" EnumName="LearnerAssignmentState">
<Documentation>
<Summary xmlns="">
<para>
LearnerAssignmentState is the state of this <a href="SlkConcepts.htm#Assignments">learner assignment</a>.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="HasInstructors" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>
HasInstructors is <b>true</b> if the assignment has instructors, <b>false</b> if not. Note that self-assigned assignments have no instructors.
</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from LearnerAssignmentItem -----
lai.Id LearnerAssignmentId,
lai.LearnerId LearnerId,
lui.[Name] LearnerName,
lui.[Key] LearnerKey,
lai.IsFinal IsFinal,
lai.NonELearningStatus NonELearningStatus,
lai.FinalPoints FinalPoints,
lai.InstructorComments InstructorComments,
----- from AssignmentItem -----
asi.Id AssignmentId,
asi.SPSiteGuid AssignmentSPSiteGuid,
asi.SPWebGuid AssignmentSPWebGuid,
asi.NonELearningLocation AssignmentNonELearningLocation,
asi.Title AssignmentTitle,
asi.StartDate AssignmentStartDate,
asi.DueDate AssignmentDueDate,
asi.PointsPossible AssignmentPointsPossible,
asi.Description AssignmentDescription,
asi.AutoReturn AssignmentAutoReturn,
asi.ShowAnswersToLearners AssignmentShowAnswersToLearners,
asi.CreatedBy AssignmentCreatedById,
cbui.[Name] AssignmentCreatedByName,
cbui.[Key] AssignmentCreatedByKey,
asi.RootActivityId RootActivityId,
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation,
pki.Manifest PackageManifest,
----- from AttemptItem -----
ati.Id AttemptId,
ati.CurrentActivityId AttemptCurrentActivityId,
ati.SuspendedActivityId AttemptSuspendedActivityId,
ati.AttemptStatus AttemptStatus,
ati.FinishedTimestamp AttemptFinishedTimestamp,
ati.LogDetailSequencing AttemptLogDetailSequencing,
ati.LogFinalSequencing AttemptLogFinalSequencing,
ati.LogRollup AttemptLogRollup,
ati.StartedTimestamp AttemptStartedTimestamp,
ati.CompletionStatus AttemptCompletionStatus,
ati.SuccessStatus AttemptSuccessStatus,
ati.TotalPoints AttemptGradedPoints,
----- computed LearnerAssignmentState -----
dbo.GetLearnerAssignmentState(asi.RootActivityId, lai.IsFinal, lai.NonELearningStatus, ati.AttemptStatus) LearnerAssignmentState,
----- computed HasInstructors -----
CASE WHEN EXISTS
(
SELECT *
FROM InstructorAssignmentItem iaiH
WHERE iaiH.AssignmentId = asi.Id
) THEN 1 ELSE 0 END HasInstructors
-----
FROM LearnerAssignmentItem lai
INNER JOIN AssignmentItem asi ON lai.AssignmentId = asi.Id
INNER JOIN UserItem lui ON lui.Id = lai.LearnerId
INNER JOIN UserItem cbui ON cbui.Id = asi.CreatedBy
INNER JOIN InstructorAssignmentItem iai ON lai.AssignmentId = iai.AssignmentId
INNER JOIN UserItem iui ON iai.InstructorId = iui.Id
LEFT OUTER JOIN ActivityPackageItem api ON asi.RootActivityId = api.Id
LEFT OUTER JOIN PackageItem pki ON api.PackageId = pki.Id
LEFT OUTER JOIN AttemptItem ati ON ati.LearnerAssignmentId = lai.Id
WHERE iui.[Key] = @UserKey
</Implementation>
<GrantQueryRight>
<Expression>1</Expression>
</GrantQueryRight>
</View>
<View Name="UserWebList">
<Documentation>
<Summary xmlns="">
<para>
Each row of this <a href="SlkSchema.htm">LearningStore view</a> represents one
entry in one user's "user Web list", for one site collection. A user Web list is
the list of Web sites that appears on the SLK E-Learning Actions page for all
document libraries within a given site collection. Each user has at most one user
Web list for each site collection (SPSite).
</para>
<para>
This view is available only in <a href="Default.htm">SLK</a> (not in
<a href="Mlc.htm">MLC</a>).
</para>
</Summary>
<Remarks xmlns="">
<para>
<b>
<a href="SlkSchema.htm">Default operation-level security</a>:</b>
Access is granted to all users.
</para>
</Remarks>
</Documentation>
<Columns>
<Column Name="SPSiteGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPSiteGuid is the GUID of the SharePoint site collection (SPSite) that this
user Web list item is associated with.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="SPWebGuid" Type="Guid">
<Documentation>
<Summary xmlns="">
<para>
SPWebGuid is the GUID of the SharePoint Web site (SPWeb) that this user Web list
item is associated with.
</para>
</Summary>
</Documentation>
</Column>
<Column Name="LastAccessTime" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>
LastAccessTime is the date/time (UTC) that this user Web list item was last
accessed via an operation such as assignment creation. (Viewing the item within
the list on the E-Learning Actions page in SLK doesn't count as an access.)
</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT SPSiteGuid, SPWebGuid, LastAccessTime
FROM UserWebListItem
WHERE OwnerKey = @UserKey
</Implementation>
<GrantQueryRight>
<Expression>1</Expression>
</GrantQueryRight>
</View>
<View Name="ActivityPackageItemView">
<Columns>
<!-- from PackageItem: -->
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Id.Field.htm">PackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.PackageFormat.Field.htm">PackageItem.PackageFormat</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageLocation" Type="String">
<Documentation>
<Summary xmlns="">
<para>PackageLocation holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Location.Field.htm">PackageItem.Location</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PackageManifest" Type="Xml">
<Documentation>
<Summary xmlns="">
<para>PackageManifest holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Manifest.Field.htm">PackageItem.Manifest</a>.</para>
</Summary>
</Documentation>
</Column>
<!-- from ActivityPackageItem: -->
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>Id holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.Id.Field.htm">ActivityPackageItem.Id</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ActivityIdFromManifest" Type="String">
<Documentation>
<Summary xmlns="">
<para>ActivityIdFromManifest holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ActivityIdFromManifest.Field.htm">ActivityPackageItem.ActivityIdFromManifest</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="OriginalPlacement" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>OriginalPlacement holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.OriginalPlacement.Field.htm">ActivityPackageItem.OriginalPlacement</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ParentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>ParentActivityId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ParentActivityId.Field.htm">ActivityPackageItem.ParentActivityId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PrimaryObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>PrimaryObjectiveId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.PrimaryObjectiveId.Field.htm">ActivityPackageItem.PrimaryObjectiveId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ResourceId" Type="ItemIdentifier" ReferencedItemTypeName="ResourceItem">
<Documentation>
<Summary xmlns="">
<para>ResourceId holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ResourceId.Field.htm">ActivityPackageItem.ResourceId</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="PrimaryResourceIdFromManifest" Type="String">
<Documentation>
<Summary xmlns="">
<para>PrimaryResourceIdFromManifest holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.PrimaryResourceFromManifest.Field.htm">ActivityPackageItem.PrimaryResourceFromManifest</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="CompletionThreshold" Type="Single">
<Documentation>
<Summary xmlns="">
<para>CompletionThreshold holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.CompletionThreshold.Field.htm">ActivityPackageItem.CompletionThreshold</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="Credit" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>Credit holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.Credit.Field.htm">ActivityPackageItem.Credit</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="IsVisibleInContents" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>IsVisibleInContents holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.IsVisibleInContents.Field.htm">ActivityPackageItem.IsVisibleInContents</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="LaunchData" Type="String">
<Documentation>
<Summary xmlns="">
<para>LaunchData holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.LaunchData.Field.htm">ActivityPackageItem.LaunchData</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MaxAttempts" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>MaxAttempts holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.MaxAttempts.Field.htm">ActivityPackageItem.MaxAttempts</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="MaxTimeAllowed" Type="Double">
<Documentation>
<Summary xmlns="">
<para>MaxTimeAllowed holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.MaxTimeAllowed.Field.htm">ActivityPackageItem.MaxTimeAllowed</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ResourceParameters" Type="String">
<Documentation>
<Summary xmlns="">
<para>ResourceParameters holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ResourceParameters.Field.htm">ActivityPackageItem.ResourceParameters</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ScaledPassingScore" Type="Single">
<Documentation>
<Summary xmlns="">
<para>ScaledPassingScore holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ScaledPassingScore.Field.htm">ActivityPackageItem.ScaledPassingScore</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="TimeLimitAction" Type="Enum" EnumName="TimeLimitAction">
<Documentation>
<Summary xmlns="">
<para>TimeLimitAction holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.TimeLimitAction.Field.htm">ActivityPackageItem.TimeLimitAction</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="Title" Type="String">
<Documentation>
<Summary xmlns="">
<para>Title holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.Title.Field.htm">ActivityPackageItem.Title</a>.</para>
</Summary>
</Documentation>
</Column>
<Column Name="ObjectivesGlobalToSystem" Type="Boolean">
<Documentation>
<Summary xmlns="">
<para>ObjectivesGlobalToSystem holds the same value as <a href="Microsoft.SharePointLearningKit.Schema.ActivityPackageItem.ObjectivesGlobalToSystem.Field.htm">ActivityPackageItem.ObjectivesGlobalToSystem</a>.</para>
</Summary>
</Documentation>
</Column>
</Columns>
<Implementation>
SELECT
----- from PackageItem -----
pki.Id PackageId,
pki.PackageFormat PackageFormat,
pki.Location PackageLocation,
pki.Manifest PackageManifest,
----- from ActivityPackageItem -----
api.Id Id,
api.ActivityIdFromManifest ActivityIdFromManifest,
api.OriginalPlacement OriginalPlacement,
api.ParentActivityId ParentActivityId,
api.PrimaryObjectiveId PrimaryObjectiveId,
api.ResourceId ResourceId,
api.PrimaryResourceFromManifest PrimaryResourceIdFromManifest,
api.CompletionThreshold CompletionThreshold,
api.Credit Credit,
api.IsVisibleInContents IsVisibleInContents,
api.LaunchData LaunchData,
api.MaxAttempts MaxAttempts,
api.MaxTimeAllowed MaxTimeAllowed,
api.ResourceParameters ResourceParameters,
api.ScaledPassingScore ScaledPassingScore,
api.TimeLimitAction TimeLimitAction,
api.Title Title,
api.ObjectivesGlobalToSystem ObjectivesGlobalToSystem
-----
FROM ActivityPackageItem api
INNER JOIN PackageItem pki on api.PackageId = pki.Id
</Implementation>
</View>
<ExtendRight Name="ExecuteSessionRight">
<Grant>
<!-- Is the user a learner or instructor on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM AttemptItem ati
LEFT OUTER JOIN LearnerAssignmentItem lai ON ati.LearnerAssignmentId = lai.Id
LEFT OUTER JOIN AssignmentItem ai ON lai.AssignmentId = ai.Id
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = ai.Id
INNER JOIN UserItem lui ON ati.LearnerId = lui.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE ati.Id = @AttemptId AND
(lui.[Key] = @UserKey OR iui.[Key]=@UserKey)
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</ExtendRight>
<ExtendRight Name="ReviewSessionRight">
<Grant>
<!-- TODO: For now, allow everyone access. -->
<Expression>
1
</Expression>
</Grant>
</ExtendRight>
<ExtendRight Name="RandomAccessSessionRight">
<Grant>
<!-- Is the user an instructor on the assignment, and is the attempt in the
Abandoned or Completed state? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM AttemptItem ati
LEFT OUTER JOIN LearnerAssignmentItem lai ON ati.LearnerAssignmentId = lai.Id
LEFT OUTER JOIN AssignmentItem ai ON lai.AssignmentId = ai.Id
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = ai.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE ati.Id = @AttemptId AND
(ati.AttemptStatus = 1 OR ati.AttemptStatus = 2) AND
iui.[Key]=@UserKey
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</ExtendRight>
<Right Name="StartAttemptOnLearnerAssignmentRight">
<Parameters>
<Parameter Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" />
</Parameters>
<Grant>
<!-- Is the user a learner or instructor on the assignment, and is the assignment an e-learning assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
INNER JOIN AssignmentItem ai ON lai.AssignmentId = ai.Id
LEFT OUTER JOIN AttemptItem ati ON lai.Id = ati.LearnerAssignmentId
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = lai.AssignmentId
INNER JOIN UserItem lui ON lai.LearnerId = lui.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE lai.Id = @LearnerAssignmentId AND
ati.Id IS NULL AND
ai.RootActivityId IS NOT NULL AND
(lui.[Key]=@UserKey OR iui.[Key]=@UserKey)
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</Right>
<Right Name="FinishLearnerAssignmentRight">
<Parameters>
<Parameter Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" />
</Parameters>
<Grant>
<!-- Is the user an instructor or learner on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = lai.AssignmentId
INNER JOIN UserItem lui ON lai.LearnerId = lui.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE lai.Id = @LearnerAssignmentId AND
(lui.[Key]=@UserKey OR iui.[Key]=@UserKey)
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</Right>
<Right Name="CompleteLearnerAssignmentRight">
<Parameters>
<Parameter Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" />
</Parameters>
<Grant>
<!-- Is the user an instructor or learner on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
LEFT OUTER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = lai.AssignmentId
INNER JOIN UserItem lui ON lai.LearnerId = lui.Id
LEFT OUTER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE lai.Id = @LearnerAssignmentId AND
(lui.[Key]=@UserKey OR iui.[Key]=@UserKey)
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</Right>
<Right Name="FinalizeLearnerAssignmentRight">
<Parameters>
<Parameter Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" />
</Parameters>
<Grant>
<!-- Is the user an instructor on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
INNER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = lai.AssignmentId
INNER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE lai.Id = @LearnerAssignmentId AND
iui.[Key]=@UserKey
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</Right>
<Right Name="ActivateLearnerAssignmentRight">
<Parameters>
<Parameter Name="LearnerAssignmentId" Type="ItemIdentifier" ReferencedItemTypeName="LearnerAssignmentItem" />
</Parameters>
<Grant>
<!-- Is the user an instructor on the assignment? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
INNER JOIN InstructorAssignmentItem iai ON iai.AssignmentId = lai.AssignmentId
INNER JOIN UserItem iui ON iai.InstructorId = iui.Id
WHERE lai.Id = @LearnerAssignmentId AND
iui.[Key]=@UserKey
) THEN 1 ELSE 0 END
</Expression>
<!-- Is the user the learner on the learner assignment, and is the assignment non-e-learning,
and is the learner assignment state NotStarted? -->
<Expression>
CASE WHEN EXISTS
(
SELECT *
FROM LearnerAssignmentItem lai
INNER JOIN UserItem lui ON lai.LearnerId = lui.Id
INNER JOIN AssignmentItem ai ON lai.AssignmentId = ai.Id
WHERE lai.Id = @LearnerAssignmentId AND
lui.[Key]=@UserKey AND
ai.RootActivityId IS NULL AND
(lai.NonELearningStatus IS NULL OR lai.NonELearningStatus = 0)
) THEN 1 ELSE 0 END
</Expression>
</Grant>
</Right>
</StoreSchema>